In this lesson, you helped little lemons set up
their database project. There are three
key steps that you carried out to set
up the project. You set up the database and MySQL Workbench using a
MySQL Server instance. You created an entity
relationship or ER diagram and implemented
it in MySQL Workbench. Then you committed the project. Let's take a few
minutes to recap how you completed these
tasks in the module. To help little lemon build a
relational database system, you designed a well-structured entity relationship
data model or ER diagram that conform to the three fundamental
normal forums. By conforming to these forums, you ensure the integrity of your database and
avoided the insertion, update and deletion anomalies. There are many professional
tools that can be used to design an ER diagram. In this module, you've
worked with MySQL Workbench. MySQL Workbench is a
unified visual tool that's used for database
modeling and data management. There are several
key advantages of the tool that you made
use of in your project. Its key advantages are
that it's open-source, cross-platform and
provide support for a visual SQL editor. It also lets you transform
your data model in a physical database schema
in a my SQL Server, you are able to
download and install a copy from
dev.mysql.com/downloads. Once you've downloaded a
copy of MySQL Workbench, you run the installer file and make sure to install
the following. My SQL Server, MySQL
Workbench, and MySQL shell. Once you created the
little lemon database, you then committed your
project using Git. Git is a free, open source distributed version
control system. You use it to manage all
your source code history. Keep a history of your commits, revert to previous versions and share code to collaborate
with other developers you downloaded and
installed get from the urlgit-scm.com
slash downloads. You are able to store your
Git repositories on GitHub. Github includes the source
control management features of get along with
other useful features. These features include
project management, support ticket management,
and bug tracking. You are also able
to use it to share, access and store repositories
including backups. Now that you've reached the
end of this module summary, the next stage of this
module is to complete the module quiz and then review
the additional resources. When you've completed
these tasks, you can then progress
to the next module.